package com.truongnha.clienttn.data.dao;

import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

public class AccountScheme {
	public static final String TABLE_NAME = "Account";
	public static final String ID = "id";
	public static final String LAST_NAME = "last_name";
	public static final String FIRST_NAME = "first_name";
	public static final String USER_NAME = "user_name";
	public static final String USER_TYPE = "user_type";
	public static final String CLASS = "class";
	public static final String SCHOOL = "school";
	public static final String BIRTHDAY = "birthday";
	public static final String USER_ID = "user_id";
	public static final String POSITION_ID = "position_id";
	public static final String CSRFTOKEN = "csrftoken";

	private static final String DATABASE_CREATE = "create table "
			+ TABLE_NAME + "(" 
			+ ID + " integer primary key  ,"
			+ LAST_NAME + " text," 
			+ FIRST_NAME + " text, "  
			+ USER_NAME + " text, "  
			+ USER_TYPE + " text, "  
			+ CLASS + " text, "  
			+ SCHOOL + " text, "  
			+ BIRTHDAY + " text, "  
			+ USER_ID + " text, "  
			+ POSITION_ID + " text, "
			+ CSRFTOKEN + " text"
			+ ");";

	public static void onCreate(SQLiteDatabase db) {
		Log.i("LOG", "on Create account table");
		db.execSQL(DATABASE_CREATE);

	}

}
